Software Development
Connecting to and Querying Databases With JDBC
Java Database Connectivity (JDBC): An Introduction to JDBC
it_jpcqdjdj_01_enus
Java Database Connectivity (JDBC): Batch Executions & Transactions with JDBC
it_jpcqdjdj_04_enus
Java Database Connectivity (JDBC): Interacting with Databases using RowSets
it_jpcqdjdj_02_enus
Java Database Connectivity (JDBC): Joining & Filtering Data with RowSets
it_jpcqdjdj_03_enus
Java Database Connectivity (JDBC): An Introduction to JDBC
Lesson Objectives
Java Database Connectivity (JDBC): An Introduction to JDBC
- discover the key concepts covered in this course
- set up your machine with a MySQL server and a client application to interact with it
- create a Maven project which uses the MySQL connector
- configure JDBC objects in order to connect to a database
- use a DataSource instance rather than a DriverManager in order to connect to a database from a Java app
- execute SELECT queries against a database using a JDBC Statement
- use a ResultSet in order to access and parse the results of a SELECT query
- create, load, and run parameterized SQL queries using the JDBC PreparedStatement
- set multiple parameters in a PreparedStatement in order to run INSERT queries
- execute UPDATE and DELETE queries and explore the data returned for each execution
- summarize the key concepts covered in this course
Overview/Description
Java Database Connectivity (JDBC) is the Java application programming interface (API) that manages the connection and execution of queries with a database. The focus of this course is to provide you hands-on experience with a variety of JDBC objects that are required to set up a connection to a relational database and run queries against it. Learn how to set up a MySQL database and use DataSource and Data Manager instances to connect to it from your Java application. Delve into objects such as Statements and PreparedStatements that enable you to execute a variety of queries against the database and familiarize yourself with the ResultSet that allows you to parse the results of the execution of a select query. You'll have the foundational knowledge to connect to and query against databases using JDBC objects after completing this course.
Java Database Connectivity (JDBC) is the Java application programming interface (API) that manages the connection and execution of queries with a database. The focus of this course is to provide you hands-on experience with a variety of JDBC objects that are required to set up a connection to a relational database and run queries against it. Learn how to set up a MySQL database and use DataSource and Data Manager instances to connect to it from your Java application. Delve into objects such as Statements and PreparedStatements that enable you to execute a variety of queries against the database and familiarize yourself with the ResultSet that allows you to parse the results of the execution of a select query. You'll have the foundational knowledge to connect to and query against databases using JDBC objects after completing this course.
Target
Prerequisites: none
Java Database Connectivity (JDBC): Batch Executions & Transactions with JDBC
Lesson Objectives
Java Database Connectivity (JDBC): Batch Executions & Transactions with JDBC
- discover the key concepts covered in this course
- use a Statement object to run a series of INSERT queries as a batch
- perform a batch execution of parameterized queries using a PreparedStatement
- describe the behavior of a batch execution, where some queries are invalid
- recognize the limitations of running related SQL queries independently
- identify the steps involved in running a set of related queries as a transaction
- divide a large chunk of queries into units that can be committed to a database using Savepoints
- use Savepoints in batch executions and recognize the behavior of a program when this is done
- summarize the key concepts covered in this course
Overview/Description
In scenarios where an application has to issue several updates, performing them in batches greatly benefits performance. A set of updates can then be wrapped in an interaction that either succeeds or fails altogether with the help of transactions in relational databases. Use this course to explore the implementation of advanced database operations using Java Database Connectivity (JDBC), specifically batch executions and transactions. Discover how executions of multiple similar queries can be optimized by aggregating them together in a batch and then executing them together and learn to set up queries to execute as transactions. You will also examine concepts, such as rollbacks, commits, and savepoints, and how these can be implemented using JDBC. You will be able to implement batch executions and transactions in a Java program using JDBC.
In scenarios where an application has to issue several updates, performing them in batches greatly benefits performance. A set of updates can then be wrapped in an interaction that either succeeds or fails altogether with the help of transactions in relational databases. Use this course to explore the implementation of advanced database operations using Java Database Connectivity (JDBC), specifically batch executions and transactions. Discover how executions of multiple similar queries can be optimized by aggregating them together in a batch and then executing them together and learn to set up queries to execute as transactions. You will also examine concepts, such as rollbacks, commits, and savepoints, and how these can be implemented using JDBC. You will be able to implement batch executions and transactions in a Java program using JDBC.
Target
Prerequisites: none
Java Database Connectivity (JDBC): Interacting with Databases using RowSets
Lesson Objectives
Java Database Connectivity (JDBC): Interacting with Databases using RowSets
- discover the key concepts covered in this course
- use a JdbcRowSet to connect to and run queries against a database and parse the results
- recognize some of the important settings of a JdbcRowSet and its default values
- move to different positions in a JdbcRowSet by using various navigation methods
- describe how the connected nature of a JdbcRowSet can be used to get any updates from underlying data
- update the content of existing rows in a database table using a JdbcRowSet
- add and delete rows from a database table using a JdbcRowSet
- describe the similarities between a JdbcRowSet and a CachedRowSet
- recognize the differences between a JdbcRowSet and a CachedRowSet
- update data in existing rows of a database table with a CachedRowSet
- perform insert and delete operations with a CachedRowSet
- summarize the key concepts covered in this course
Overview/Description
RowSet is a Java Database Connectivity (JDBC) object that holds tabular data in a form that makes it more adaptable and easier to use. Explore how to enable database operations from within your Java application using RowSet type in JDBC with the help of this course. Explore RowSets within JDBC and how they don't just represent the results of query execution, but include methods to connect to and run queries against a database as well. The course will also help you examine JdbcRowSets in detail and distinguish it from CachedRowSets. After finishing the course, you'll have an understanding of RowSets in JDBC and how connected and disconnected RowSets differ from each other.
RowSet is a Java Database Connectivity (JDBC) object that holds tabular data in a form that makes it more adaptable and easier to use. Explore how to enable database operations from within your Java application using RowSet type in JDBC with the help of this course. Explore RowSets within JDBC and how they don't just represent the results of query execution, but include methods to connect to and run queries against a database as well. The course will also help you examine JdbcRowSets in detail and distinguish it from CachedRowSets. After finishing the course, you'll have an understanding of RowSets in JDBC and how connected and disconnected RowSets differ from each other.
Target
Prerequisites: none
Java Database Connectivity (JDBC): Joining & Filtering Data with RowSets
Lesson Objectives
Java Database Connectivity (JDBC): Joining & Filtering Data with RowSets
- discover the key concepts covered in this course
- create a number of related database tables, which can be joined based on common fields
- implement a join operation in a Java program using a JDBC JoinRowSet
- recognize the types of join operations that are supported by a JoinRowSet implementation
- join multiple tables involving different join fields using a JoinRowSet
- define the filtering conditions to be applied to a FilteredRowSet when implementing the Predicate class
- apply a predicate instance with a FilteredRowSet to apply a filter to a RowSet
- configure a predicate implementation to use multiple conditions when defining a filter
- summarize the key concepts covered in this course
Overview/Description
A CachedRowSet is a Java Database Connectivity (JDBC) RowSet where the rows are cached, and the RowSet is disconnected (i.e., doesn't maintain an active connection to the database). CachedRowSets allow you to work on data without keeping your database connection open all the time. This course will help you get acquainted with specialized implementations of the CachedRowSet - the JoinRowSet and FilteredRowSet - which enable offline joins and data filtering. Discover how to implement join operations using a JoinRowSet and examine the use of a FilteredRowSet in implementing the equivalent of the WHERE clause in a SQL query. You will also explore the use of predicate class in order to achieve this. Upon completion of this course, you'll be able to carry out join and filter operations within a Java program using JDBC JoinRowSets and FilteredRowSets.
A CachedRowSet is a Java Database Connectivity (JDBC) RowSet where the rows are cached, and the RowSet is disconnected (i.e., doesn't maintain an active connection to the database). CachedRowSets allow you to work on data without keeping your database connection open all the time. This course will help you get acquainted with specialized implementations of the CachedRowSet - the JoinRowSet and FilteredRowSet - which enable offline joins and data filtering. Discover how to implement join operations using a JoinRowSet and examine the use of a FilteredRowSet in implementing the equivalent of the WHERE clause in a SQL query. You will also explore the use of predicate class in order to achieve this. Upon completion of this course, you'll be able to carry out join and filter operations within a Java program using JDBC JoinRowSets and FilteredRowSets.
Target
Prerequisites: none
